﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StorageExcel.aspx.cs" Inherits="Storage_StorageExcel" %>

<%@ Register Src="Position.ascx" TagName="Position" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>正贸仓储物流管理系统</title>
    <link href="../css/css.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript">

        function fPopUpDlg(URL, Target, form)   //
        {
            now = new Date();
            var rom;
            var rom1
            rom = Math.ceil(Math.random() * 10000);
            rom1 = now.getFullYear() + "" + now.getMonth() + "" + now.getDate() + "" + now.getHours() + "" + now.getMinutes() + "" + now.getSeconds() + "" + rom;

            showx = event.screenX - event.offsetX - 4; // + deltaX;
            showy = event.screenY - event.offsetY + 18; // + deltaY;
            retval = window.showModalDialog(URL + "?radmom=" + rom1, "", "dialogWidth:800px; dialogHeight:400px; dialogLeft:" + showx + "px; dialogTop:" + showy + "px; status:no; directories:yes;help:no;scrollbars:no;Resizable=no; ");

            if (retval != null) {
                var Material = retval.split(",");
                document.forms(0).txt_Mat_Code.value = Material[1];           //物料编码

            }
        }
        
    </script>

    <script type="text/javascript">
        window.onload = function() {
            var a = document.getElementById("loading");
            a.parentNode.removeChild(a);
        }
        document.write('<div id="loading" style="line-height:122px;"><table cellpadding="0" width="100%"><Tr><Td align="center" height="500" valign="middle"><img src="../Images/loading.gif"></td></tr></table></div>');
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
                <td style="height: 30px">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td style="background-image: url(../images/tab_03.gif); background-repeat: repeat-x;
                                width: 12px;">
                                &nbsp;
                            </td>
                            <td style="background-image: url(../images/tab_05.gif); background-repeat: repeat-x;
                                height: 30px;">
                                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <td style="width: 46%; vertical-align: middle;">
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td style="width: 5%; vertical-align: middle;">
                                                        <img src="../images/tb.gif" width="16" height="16" />
                                                    </td>
                                                    <td style="width: 95%;">
                                                        <span>你当前的位置</span>：库存管理-库存导出
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                        <td width="54%">
                                        </td>
                                    </tr>
                                </table>
                            </td>
                            <td width="16" style="background-image: url(../images/tab_07.gif); height: 30px;">
                                &nbsp;
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td style="background-image: url(../images/tab_12.gif); width: 8px;">
                                &nbsp;
                            </td>
                            <td>
                                <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 1px solid #b5d6e6;">
                                    <tr>
                                        <td style="padding: 2px;">
                                            <table width="100%" cellspacing="0" cellpadding="0" border="1" bordercolordark="#ffffff"
                                                bordercolorlight="#b5d6e6">
                                                <tr>
                                                    <td style="width: 7%;" align="right">
                                                        物料编码：
                                                    </td>
                                                    <td style="width: 10%;">
                                                        <asp:TextBox ID="txt_Mat_Code" runat="server" Style="width: 100px; height: 14px;
                                                            border: solid 1px #b5d6e6; font-size: 9pt;"></asp:TextBox><input onclick="fPopUpDlg('../Stock/BookList.aspx','Item',form1);return false;"
                                                                src="../images/fc.gif" style="border-right: 0px; border-top: 0px; border-left: 0px;
                                                                width: 14px; border-bottom: 0px; height: 11px" type="image" />
                                                    </td>
                                                    <td style="width: 6%;" align="right">
                                                        托盘号：
                                                    </td>
                                                    <td style="width: 10%;">
                                                        <asp:TextBox ID="txt_Tray_ID" runat="server" Style="width: 100px; height: 14px; border: solid 1px #b5d6e6;
                                                            font-size: 9pt;"></asp:TextBox>
                                                    </td>
                                                    <td style="width: 350px; padding-top: 1px;">
                                                        <uc1:Position ID="Position1" runat="server" />
                                                    </td>
                                                    <td style="width: 5%;" align="right">
                                                        库区：
                                                    </td>
                                                    <td style="width: 10%;">
                                                        <asp:DropDownList ID="ddlZoneID" runat="server">
                                                        </asp:DropDownList>
                                                    </td>
                                                    <td style="padding-top: 1px;">
                                                        <asp:ImageButton ID="ibtn_Search" ImageUrl="../images/btn/btn_Search.gif" runat="server"
                                                            OnClick="ibtn_Search_Click" />
                                                        <asp:ImageButton ID="ibtn_Excel" ImageUrl="../images/btn/btn_Excel.gif" runat="server"
                                                            OnClick="ibtn_Excel_Click" />
                                                        <asp:ImageButton ID="ibtn_ERP" ImageUrl="../images/btn/btn_ERP_DB.gif" runat="server" Visible="false"
                                                            OnClick="ibtn_ERP_Click" />
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="8" align="right">
                                                        <asp:Label ID="lab_Err" runat="server" Text=""></asp:Label>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td style="padding: 2px;">
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td align="center">
                                                        <div style="margin-left: 0px; margin-top: 3px; width: 100%; height: 520px; overflow-x: auto;
                                                            overflow-y: auto;">
                                                            <asp:GridView ID="gv" runat="server" AutoGenerateColumns="False" Width="100%" BorderWidth="1px"
                                                                BorderColor="#B5D6E6" CellPadding="0" AllowPaging="true" 
                                                                OnRowDataBound="gv_RowDataBound" PageSize="100" 
                                                                onpageindexchanging="gv_PageIndexChanging">
                                                                <Columns>
                                                                    <asp:TemplateField HeaderText="编号">
                                                                        <ItemTemplate>
                                                                            <asp:Label ID="labCodeType" runat="server" Text="<%#Container.DataItemIndex+1%>"></asp:Label>
                                                                        </ItemTemplate>
                                                                        <ItemStyle Width="30" />
                                                                    </asp:TemplateField>
                                                                    <asp:BoundField DataField="Pos_ID" HeaderText="货位号">
                                                                        <ItemStyle Width="10%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="Mat_Code" HeaderText="物料编码">
                                                                        <ItemStyle Width="10%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="Mat_Name" HeaderText="物料名称"></asp:BoundField>
                                                                    <asp:BoundField DataField="Mat_Num" HeaderText="物料数量">
                                                                        <ItemStyle Width="8%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="Unit_Base" HeaderText="单位">
                                                                        <ItemStyle Width="5%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="S01" HeaderText="规格">
                                                                        <ItemStyle Width="8%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="CDT" HeaderText="写入日期" DataFormatString="{0:yyyy-MM-dd}">
                                                                        <ItemStyle Width="8%" />
                                                                    </asp:BoundField>
                                                                    <asp:BoundField DataField="CDT" HeaderText="写入时间" DataFormatString="{0:hh-mm-ss}">
                                                                        <ItemStyle Width="8%" />
                                                                    </asp:BoundField>
                                                                </Columns>
                                                                <HeaderStyle HorizontalAlign="Center" CssClass="gvHeader" />
                                                                <RowStyle CssClass="gvRow" HorizontalAlign="Center" />
                                                            </asp:GridView>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                            <td style="background-image: url(../images/tab_15.gif); width: 8px;">
                                &nbsp;
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td style="background-image: url(../images/tab_19.gif); height: 35px;">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td style="width: 12px; height: 35px;">
                                <img src="../images/tab_18.gif" width="12" height="35" />
                            </td>
                            <td>
                                &nbsp;
                            </td>
                            <td width="16">
                                <img src="../images/tab_20.gif" width="16" height="35" />
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
